{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cost Worksheet"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Cost Worksheet","index":0,"n_rows":56,"n_cols":27,"rows_kept":56,"merged":[[2,1,2,2],[5,1,5,2],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[13,1,13,2],[13,3,13,6],[17,1,17,3],[24,1,24,2],[27,1,28,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,28,25],[27,26,28,27],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[33,26,33,27],[34,1,34,27],[37,1,37,3],[38,1,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[38,20,38,21],[38,22,38,23],[38,24,39,24],[39,0,44,0],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,1,46,23],[45,24,46,24],[47,1,47,24]]}
[]
[" ","State of Georgia"]
[" ","In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[" ","Attachment V - Pharmacy Clinical Management Services Cost Worksheet"]
[" "," "]
[" ","SUPPLIER LEGAL ENTITY NAME:","Conduent State Healthcare, LLC"]
[null,"SUPPLIER REPRESENTATIVE NAME:","Lydie Quebe"]
[" ","SUPPLIER REPRESENTATIVE TITLE:","Vice President"]
[null,"DATE:","2024-04-24"]
[" "]
[null,"TOTAL EVALUATION COST AMOUNT (Sum of Evaluation Costs Below):",null,{"$f":"+Y34+D25","v":{"v":15064736,"d":"$15,064,736.00"}}]
[" ",null," "]
[null,"Table A"]
[null,"Instructions: Please enter the costs to implement your services and/or Solution."]
[null,"Service Design, Development, and Implementation (DDI) Cost"]
[null,null,"Initial Cost","CPI-U Adjusted Cost"]
[null,"Project Planning and Startup",{"v":104108,"d":"$104,108.00"},{"$f":"+C20*$C$56","v":{"v":104108,"d":"$104,108.00"}}]
[null,"Design, Development, and Testing",{"v":175090,"d":"$175,090.00"},{"$f":"+C21*$C$56","v":{"v":175090,"d":"$175,090.00"}}]
[null,"Operational Readiness and Production Cutover",{"v":42589,"d":"$42,589.00"},{"$f":"+C22*$C$56","v":{"v":42589,"d":"$42,589.00"}}]
[null,"Training",{"v":66250,"d":"$66,250.00"},{"$f":"+C23*$C$56","v":{"v":66250,"d":"$66,250.00"}}]
[null,"Acceptance, Deployment",{"v":85179,"d":"$85,179.00"},{"$f":"+C24*$C$56","v":{"v":85179,"d":"$85,179.00"}}]
[null,"Total DDI Costs:",null,{"$f":"SUM(D20:D24)","v":{"v":473216,"d":"$473,216.00"}}]
[]
[null,"Table B"]
[null,"Operations and Maintenance (O&M)",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Clinical Management Services O&M Administration",null,"For Informational Purposes Only\nAnnual Average Clinical Management Services Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Administration Fee"]
[null,"The monthly administration fee should include all the O&M costs to include, but not limited to the following:\n1.  State Advisory Board Support\n2.  Planning and Materials\n3.  Staffing\n4.  Utilization Management:  Development and Maintenance of PA Criteria for PDL and PADL \n5.  Technology Services (e.g., Document Repository)                                                                       \n(See Attachment  G - Pharmacy Clinical Management Services Scope of Work)"]
[null,"Total Monthly Cost",null,null,{"v":106069,"d":"$106,069"},{"$f":"E32*C56","v":{"v":106069,"d":"$106,069"}},{"v":109251,"d":"$109,251"},{"$f":"G32*C56","v":{"v":109251,"d":"$109,251"}},{"v":112528,"d":"$112,528"},{"$f":"I32*C56","v":{"v":112528,"d":"$112,528"}},{"v":115904,"d":"$115,904"},{"$f":"K32*C56","v":{"v":115904,"d":"$115,904"}},{"v":119381,"d":"$119,381"},{"$f":"M32*C56","v":{"v":119381,"d":"$119,381"}},{"v":122963,"d":"$122,963"},{"$f":"O32*C56","v":{"v":122963,"d":"$122,963"}},{"v":126652,"d":"$126,652"},{"$f":"Q32*C56","v":{"v":126652,"d":"$126,652"}},{"v":130451,"d":"$130,451"},{"$f":"S32*C56","v":{"v":130451,"d":"$130,451"}},{"v":134365,"d":"$134,365"},{"$f":"U32*C56","v":{"v":134365,"d":"$134,365"}},{"v":138396,"d":"$138,396"},{"$f":"W32*C56","v":{"v":138396,"d":"$138,396"}}]
[{"$nulls":4},{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months"]
[null,"Total Period Cost",null,null,{"$f":"F32*E33","v":{"v":1272828,"d":"= $ 1,272,828"}},null,{"$f":"H32*G33","v":{"v":1311012,"d":"= $ 1,311,012"}},null,{"$f":"J32*I33","v":{"v":1350336,"d":"= $ 1,350,336"}},null,{"$f":"L32*K33","v":{"v":1390848,"d":"= $ 1,390,848"}},null,{"$f":"N32*M33","v":{"v":1432572,"d":"= $ 1,432,572"}},null,{"$f":"P32*O33","v":{"v":1475556,"d":"= $ 1,475,556"}},null,{"$f":"R32*Q33","v":{"v":1519824,"d":"= $ 1,519,824"}},null,{"$f":"T32*S33","v":{"v":1565412,"d":"= $ 1,565,412"}},null,{"$f":"V32*U33","v":{"v":1612380,"d":"= $ 1,612,380"}},null,{"$f":"X32*W33","v":{"v":1660752,"d":"= $ 1,660,752"}},null,{"$f":"SUM(E34:W34)","v":{"v":14591520,"d":"= $ 14,591,520"}},null,{"$f":"Y34/10","v":{"v":1459152,"d":"= $ 1,459,152"}}]
[]
[]
[null,"Table C "]
[null,"Instructions: Complete the section below by entering the Hourly Rate in the yellow boxes for each identified Role. As may be requested by the State on a case by case basis and agreed upon by the Contractor, the Contractor will provide ad hoc services related to potential tasks as described below.\n\nNote: These charges will only be billed for project-related services not specified in the eRFP and requested by the State for such services in writing. The total cost for all State requested and approved projects shall not exceed the amount indicated by the State in its Participating Addendum. The proposed costs will not be evaluated as part of the total contract value."]
["Staff Roles and Responsibilities","Ad Hoc Professional Services",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Average of Hourly Rates"]
[null,"Role","Potential Responsibilities",null,"Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate"]
[null,"Clinical Pharmacist / Account Manager","Provides clinical consulting services for special projects. ",null,{"v":150,"d":"$150.00"},{"$f":"MAX(ROUND(E41*$C$56,2),0)","v":{"v":150,"d":"$150.00"}},{"v":155,"d":"$155.00"},{"$f":"MAX(ROUND(G41*$C$56,2),0)","v":{"v":155,"d":"$155.00"}},{"v":160,"d":"$160.00"},{"$f":"MAX(ROUND(I41*$C$56,2),0)","v":{"v":160,"d":"$160.00"}},{"v":164,"d":"$164.00"},{"$f":"MAX(ROUND(K41*$C$56,2),0)","v":{"v":164,"d":"$164.00"}},{"v":169,"d":"$169.00"},{"$f":"MAX(ROUND(M41*$C$56,2),0)","v":{"v":169,"d":"$169.00"}},{"v":174,"d":"$174.00"},{"$f":"MAX(ROUND(O41*$C$56,2),0)","v":{"v":174,"d":"$174.00"}},{"v":180,"d":"$180.00"},{"$f":"MAX(ROUND(Q41*$C$56,2),0)","v":{"v":180,"d":"$180.00"}},{"v":185,"d":"$185.00"},{"$f":"MAX(ROUND(S41*$C$56,2),0)","v":{"v":185,"d":"$185.00"}},{"v":191,"d":"$191.00"},{"$f":"MAX(ROUND(U41*$C$56,2),0)","v":{"v":191,"d":"$191.00"}},{"v":196,"d":"$196.00"},{"$f":"MAX(ROUND(W41*$C$56,2),0)","v":{"v":196,"d":"$196.00"}},{"$f":"(F41+H41+J41+L41+N41+P41+R41+T41+V41+X41)/10","v":{"v":172.4,"d":"$172.40"}}]
[null,"Business Analyst","Evaluates business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing Solutions.",null,{"v":75,"d":"$75.00"},{"$f":"MAX(ROUND(E42*$C$56,2),0)","v":{"v":75,"d":"$75.00"}},{"v":78,"d":"$78.00"},{"$f":"MAX(ROUND(G42*$C$56,2),0)","v":{"v":78,"d":"$78.00"}},{"v":80,"d":"$80.00"},{"$f":"MAX(ROUND(I42*$C$56,2),0)","v":{"v":80,"d":"$80.00"}},{"v":82,"d":"$82.00"},{"$f":"MAX(ROUND(K42*$C$56,2),0)","v":{"v":82,"d":"$82.00"}},{"v":85,"d":"$85.00"},{"$f":"MAX(ROUND(M42*$C$56,2),0)","v":{"v":85,"d":"$85.00"}},{"v":87,"d":"$87.00"},{"$f":"MAX(ROUND(O42*$C$56,2),0)","v":{"v":87,"d":"$87.00"}},{"v":90,"d":"$90.00"},{"$f":"MAX(ROUND(Q42*$C$56,2),0)","v":{"v":90,"d":"$90.00"}},{"v":93,"d":"$93.00"},{"$f":"MAX(ROUND(S42*$C$56,2),0)","v":{"v":93,"d":"$93.00"}},{"v":96,"d":"$96.00"},{"$f":"MAX(ROUND(U42*$C$56,2),0)","v":{"v":96,"d":"$96.00"}},{"v":98,"d":"$98.00"},{"$f":"MAX(ROUND(W42*$C$56,2),0)","v":{"v":98,"d":"$98.00"}},{"$f":"(F42+H42+J42+L42+N42+P42+R42+T42+V42+X42)/10","v":{"v":86.4,"d":"$86.40"}}]
[null,"Senior Developer","Responsible for designing, testing, and implementing new and updated software programs.",null,{"v":131,"d":"$131.00"},{"$f":"MAX(ROUND(E43*$C$56,2),0)","v":{"v":131,"d":"$131.00"}},{"v":135,"d":"$135.00"},{"$f":"MAX(ROUND(G43*$C$56,2),0)","v":{"v":135,"d":"$135.00"}},{"v":139,"d":"$139.00"},{"$f":"MAX(ROUND(I43*$C$56,2),0)","v":{"v":139,"d":"$139.00"}},{"v":143,"d":"$143.00"},{"$f":"MAX(ROUND(K43*$C$56,2),0)","v":{"v":143,"d":"$143.00"}},{"v":147,"d":"$147.00"},{"$f":"MAX(ROUND(M43*$C$56,2),0)","v":{"v":147,"d":"$147.00"}},{"v":152,"d":"$152.00"},{"$f":"MAX(ROUND(O43*$C$56,2),0)","v":{"v":152,"d":"$152.00"}},{"v":156,"d":"$156.00"},{"$f":"MAX(ROUND(Q43*$C$56,2),0)","v":{"v":156,"d":"$156.00"}},{"v":161,"d":"$161.00"},{"$f":"MAX(ROUND(S43*$C$56,2),0)","v":{"v":161,"d":"$161.00"}},{"v":166,"d":"$166.00"},{"$f":"MAX(ROUND(U43*$C$56,2),0)","v":{"v":166,"d":"$166.00"}},{"v":171,"d":"$171.00"},{"$f":"MAX(ROUND(W43*$C$56,2),0)","v":{"v":171,"d":"$171.00"}},{"v":150.1,"d":"$150.10"}]
[null,"Developer","Responsible for developing, coding, installing, and maintaining software systems.",null,{"v":108,"d":"$108.00"},{"$f":"MAX(ROUND(E44*$C$56,2),0)","v":{"v":108,"d":"$108.00"}},{"v":111,"d":"$111.00"},{"$f":"MAX(ROUND(G44*$C$56,2),0)","v":{"v":111,"d":"$111.00"}},{"v":114,"d":"$114.00"},{"$f":"MAX(ROUND(I44*$C$56,2),0)","v":{"v":114,"d":"$114.00"}},{"v":117,"d":"$117.00"},{"$f":"MAX(ROUND(K44*$C$56,2),0)","v":{"v":117,"d":"$117.00"}},{"v":121,"d":"$121.00"},{"$f":"MAX(ROUND(M44*$C$56,2),0)","v":{"v":121,"d":"$121.00"}},{"v":125,"d":"$125.00"},{"$f":"MAX(ROUND(O44*$C$56,2),0)","v":{"v":125,"d":"$125.00"}},{"v":128,"d":"$128.00"},{"$f":"MAX(ROUND(Q44*$C$56,2),0)","v":{"v":128,"d":"$128.00"}},{"v":132,"d":"$132.00"},{"$f":"MAX(ROUND(S44*$C$56,2),0)","v":{"v":132,"d":"$132.00"}},{"v":136,"d":"$136.00"},{"$f":"MAX(ROUND(U44*$C$56,2),0)","v":{"v":136,"d":"$136.00"}},{"v":140,"d":"$140.00"},{"$f":"MAX(ROUND(W44*$C$56,2),0)","v":{"v":140,"d":"$140.00"}},{"v":123.2,"d":"$123.20"}]
[null,"Quality assurance/Test","Works with the development team to debug code, correct errors, and troubleshoot any issues with software code.",null,{"v":84,"d":"$84.00"},{"$f":"MAX(ROUND(E45*$C$56,2),0)","v":{"v":84,"d":"$84.00"}},{"v":87,"d":"$87.00"},{"$f":"MAX(ROUND(G45*$C$56,2),0)","v":{"v":87,"d":"$87.00"}},{"v":90,"d":"$90.00"},{"$f":"MAX(ROUND(I45*$C$56,2),0)","v":{"v":90,"d":"$90.00"}},{"v":92,"d":"$92.00"},{"$f":"MAX(ROUND(K45*$C$56,2),0)","v":{"v":92,"d":"$92.00"}},{"v":95,"d":"$95.00"},{"$f":"MAX(ROUND(M45*$C$56,2),0)","v":{"v":95,"d":"$95.00"}},{"v":98,"d":"$98.00"},{"$f":"MAX(ROUND(O45*$C$56,2),0)","v":{"v":98,"d":"$98.00"}},{"v":101,"d":"$101.00"},{"$f":"MAX(ROUND(Q45*$C$56,2),0)","v":{"v":101,"d":"$101.00"}},{"v":104,"d":"$104.00"},{"$f":"MAX(ROUND(S45*$C$56,2),0)","v":{"v":104,"d":"$104.00"}},{"v":107,"d":"$107.00"},{"$f":"MAX(ROUND(U45*$C$56,2),0)","v":{"v":107,"d":"$107.00"}},{"v":110,"d":"$110.00"},{"$f":"MAX(ROUND(W45*$C$56,2),0)","v":{"v":110,"d":"$110.00"}},{"v":96.8,"d":"$96.80"}]
[null,"Total Ad Hoc Professional Services Cost (Sum of 10-Year Average of Hourly Rates for all Identified Roles)",{"$nulls":22},{"$f":"SUM(Y41:Y45)","v":{"v":628.9,"d":"$628.90"}}]
[]
[]
[]
[null,"Table D"]
[null,"Consumer Price Index Urban (CPI-U) Adjustment:"]
[null,"A. CPI-U for Master Agreement Date MM/DD/20YY:",{"v":0,"d":"0.000000"}]
[null,"B. CPI-U for Participating Addendum Date:",{"v":0,"d":"0.000000"}]
[null,"C. Index Point Change equals B minus A:",{"$f":"C53-C52","v":{"v":0,"d":"0.000000"}}]
[null,"D. Equals C divided by A:",{"$f":"IFERROR(C54/C52,0)","v":{"v":0,"d":"0.000000"}}]
[null,"E. CPI-U Inflation Percentage equals B plus 1.00:",{"$f":"C55+1","v":{"v":1,"d":"1.000000"}}]